package bean;

//用户类
public class customer {
    Integer pid;
    String name;
    String phoneNumber;
    String password;

    public customer() {

    }

    public customer(Integer pid,String name,String phoneNumber,String password){
        this.pid = pid;
        this.name = name;
        this.phoneNumber = phoneNumber;
        this.password = password;

    }

    public Integer getPid() {
        return pid;
    }

    public void setPid(Integer pid) {
        this.pid = pid;
    }



    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(String phoneNumber) {
        this.phoneNumber = phoneNumber;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}


/*create table customer(

id int identity(1,1) ,

name varchar(20),

phonenumber varchar(11) PRIMARY key,

password varchar(16)

)

INSERT INTO customer (name, phonenumber, password) VALUES
('Alice', '12345678901', 'password1'),
('Bob', '23456789012', 'password2'),
('Charlie', '34567890123', 'password3'),
('Dave', '45678901234', 'password4'),
('Eve', '56789012345', 'password5'),
('Frank', '67890123456', 'password6'),
('Grace', '78901234567', 'password7'),
('Henry', '89012345678', 'password8'),
('Isaac', '90123456789', 'password9'),
('Jack', '01234567890', 'password10'),
('Karen', '12345678911', 'password11'),
('Lily', '23456789122', 'password12'),
('Mike', '34567891233', 'password13'),
('Nancy', '45678902344', 'password14'),
('Oliver', '56789013455', 'password15'),
('Peter', '67890124566', 'password16');

 */